Brents Web Site

Web Data Management
Last revised: Feb 24, 2016

Syllabus

Instructor's Notes  
Web Development and Design 101
Unit 1: Web Client / Server Concepts, Chapter 1
Unit 1: Web Client / Server Concepts, Chapter 2
Background required to create PHP & MySQL based web sites
Installing XAMPP and MySQL Notes for how to install XAMPP and MySQL in PortableApps (converting to lab)
Unit 2: PHP Sequential Processing
PHP syntax to accomplish sequential processing tasks.
Unit 3: The MVC Pattern
     MVC PowerPoint
How to use the MVC (model, view, controller) pattern to develop web sites.
(PowerPoint) Download this file to your computer and then view.
Unit 4: Functions and Include Files
How to write your own PHP functions and retrieve/include them from PHP libraries
Unit 4: powerpoint slides
powerpoint presentation
Unit 5: PHP Control Structures and Arrays
PHP syntax to implement decision and repetition processing (includes arrays)
Unit 6: Database Access
How to use connect to a database using an MVC model.
Unit 7: Session Variables and Login Screens
How to use session variables to save data between browser "sessions". How to create a login screen to restrict access to your website.


Lecture Videos  
YouTube Videos
In Class Exercises  
Unit 1 class demo
Unit 2 class demo
Unit 3 class demo
Unit 4 class demo
Unit 5 class demo - control structures
Unit 5 class demo - validation
Unit 5 class demo - separation of bus class validation
Unit 5 class demo - new key press jquery example
Unit 6: async example
Unit 6: async example employee database
Unit 6: dependency injection example

Assignments  
Due Date Policies Policies regarding assignment due dates, NQA coupons, updates and tickets
Tickets Mini-assignments due before the next class period.
Unit 2 - PHP Sequential Processing Syntax Version 1 of the Tip Calculator web application
Unit 3 - MVC Basics Create a basic MVC pattern web site
Unit 4 - Functions and Include Files Version 2 of the Tip Calculator web application that incorporates functions.
Unit 5 - Control Structures and Arrays Version 3 of the Tip Calculator web application
Unit 6 - PDO and MVC
            Assignment Starter Files
Create a complete web site that provides complete CRUD processing following the MVC model.
Unit 7 - Session Variables and Login Screens Use a mini-website to demonstrate login screens and session variables
Update the Unit 6 assignment to include a login screen and session variable

Evaluation Sheets Evaluate your own programs before turning them in.
Unit 3 - MVC Evaluation sheet for the Unit 3 project
Unit 4 - Functions Evaluation sheet for the Unit 4 project
Unit 5 - Control Structures, Arrays, Validation Evaluation sheet for the Unit 5 project
Unit 6 - MVC and PDO Evaluation sheet for the Unit 6 Student-Selected project
Unit 6 - MVC and PDO Red Cross Evaluation sheet for the Unit 6 Red Cross project
Unit 7 - Session Variables & Login Screens Evaluation sheet for the Unit 7 project

Handouts
Image Manipulation
Image Manipulation Video
How to change existing images: format, size, cropping, transparency. Demo using Paint.Net
CSS 2.1 Validator W3C web site that scans your CSS file to ensure it complies with the standard
Eclipse and PHP
      Download Eclipse for PHP
How to use and configure Eclipse to create and debug PHP pages.

Programming Tips  
DevDocs Website with consolidated documentation for HTML, CSS, JavaScript, PHP, jQuery and more.
Code Academy Website with (completely) free lessons for HTML, CSS, jQuery, JavaScript, PHP and more.
Code School Website with lessons in HTML, CSS, JavaScript, jQuery, iOS, Objective-C, and more. Some are free. All courses available for $29/month.
Develop PHP Website Everything you ever wanted to know about HTML, CSS, PHP, MySQL, JavaScript
Includes a complete list PHP functions!
About.com JavaScript A ton of useful code samples
Sign up for the free, weekly JavaScript newsletter

Web Servers / Hosts  
Charter Communications
http://www.findmyfreehost.com
http://www.free-web-space-finder.com
http://www.freewebspace.net
http://www.tripod.lycos.com
http://geocities.yahoo.com/home
http://smorgasbord.freeservers.com
Links to sites that offer free web hosting.
www.fatcow.com FatCow is a hosting site


Course Topics and Schedule
Anticipated Lecture and Assignment Schedule lecture and assignment schedule


 
MSTC Stevens Point